THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

LINDI REGION

 FORM FOUR PRE NATIONAL EXAMINATION

036/1: INFORMATION AND COMPUTER STUDIES (ICS)

 (For Both School and Private Candidates)

Time: 3:00 Hours SEPTEMBER 2023

Instructions

1. This paper consists of sections A, B and C with a total of eleven (11) questions.
2. Answer all questions in sections A, B and ONLY TWO (2) questions in section C.
3. Calculators, cellular phones and any unauthorized materials are not allowed in the examination room.
4. Write your Examination Number on every page of your answer booklet(s).

SECTION A (16 MARKS)

Answer all questions in this section

1. For each of the following items (i) - (x), choose the correct answer from among the given alternatives and write its letter beside the item number in the answer booklet provided.

1. The end product of the computer processing is known as

1. News
2. Data
3. Program
4. Information.
5. Input

2. A file system extension used by default when saving a new word document in MS word.

1. .doc
2. .docx
3. .txt
4. .xlsx
5. .docc

3. What does an advertisement with a combination of text, audio, pictures and some animations presents?

1. Hyperlink presentation 
2. Hypermedia presentation.
3. Multimedia presentation. 
4. Single media presentation.
5. Interactivity presentation.

4. Which method is best for protecting the computer against short circuiting?

1. Providing standby generator.
2. Providing fire extinguisher.
3. Providing surge protector.
4. Providing insulated cables.
5. Providing air ventilation.

5. The correct sequence of computer arranged in descending order according to their physical size and processing power is.

1. Mainframe computer, minicomputer, supercomputer.
2. Minicomputer, mainframe computer, supercomputer.
3. Minicomputer, supercomputer, mainframe computer.
4. Supercomputer, mainframe computer, minicomputer.
5. Mainframe computer, supercomputer, minicomputer.

6. Which object will you use to create a form in Microsoft access?

1. Table and queries.
2. Queries and design views.
3. Table and reports.
4. Queries and reports.
5. Table and design views.

7. What is the function of the following combination of keys is used to save the new Microsoft word document.

1. Alt+ S
2. Shift+S
3. Ctrl+S
4. Ctrl+ E
5. Ctrl+Z

8. Cell A4, A7, C4, C5 and C7 contain value 5, 5, 12, 2 and 6 respectively. Then in cell D a formula =C5*(A4+A7)-(C4/C7) is entered. What will be the value for cell D?

1. 28
2. 18
3. 8
4. 14
5. 16

9. Which of the following computer generation is characterized by Very Large Scale Integrated Circuit (VLSI)

1. First generation
2. Third generation
3. Second generation.
4. Fourth generation.
5. Fifth generation

10. Computer networks without a server are called

1. Client-server
2. Network server.
3. Peer to peer
4. Personal networks.
5. None server networks

2. Match the items in LIST A with the most correct response in LIST B by writing the letter of the response beside item number in the answer sheet(s) provided.

SECTION B: (54 Marks)

Answer all questions in this section

3. (a) What is information dissemination?  

(b)Information dissemination is very important in s society as it help to distribute information quickly. Write down four (4) advantages of information.

(c) Explain three (3) qualities of good information.

4. (a) Explain three importance of database system in daily life.

(b)One of the Government institutions has two different Departments. One department uses paper-based database while other use computerized database. Which department will work more efficient? Give three reasons for your answer.

(c) Distinguish between flat file database and relational database.

5. (a) Why do we use domain name to open websites instead of their IP address?

(b) What are two (2) roles of HTML form on website?

(c)Write the HTML codes which will display the following output on a web browser.

6. (a) Using your spreadsheet knowledge, indicate the data type that will be assigned in the following entries.

(i)December 14, 2008

(ii) Total scores

(iii) $ 2,000

(iv) =Average (A3:E3)

(b) The spreadsheet below describes telephone usage for accessing the internet and costs. The cost need to be calculated. The minutes are multiplied by Tarrif 1 to obtain the sub-total.the VAT is based on the sub-total and the total is obtained by adding the sub-total to the VAT

(i) What formula was used to find the total time spent on the Internet?

(ii) What formula was used to find the average time spent on the Internet?

(iii) Using absolute referencing, what formula was used to find sub-total?

(iv) Using absolute referencing, what formula was used to find VAT?

7. (a) Define the term search engine.

(b) What is the difference between IP address and MAC address?

(c) Your head of school wishes to be connected to internet. He/she already has a Personal Computer, a printer, and access to Telephone line. However, he/she understand that a modem is needed. State why a modem is required to connect him/her to the internet

(d) (i) Suggest and explain any application area in which you would expect a supermarket retail manager to use the internet

(ii) A file in a Mingoyo secondary school website can be accessed via the following URL: http://www.MingoyoSec.ac.tz/results/form_4_results.pdf. Briefly explain the parts of this address.

8. (a) Define the term network topology.

(b)Explain two (2) functions of the Network Interface Card (NIC).

(c) State and briefly describe the following types of physical network topologies.

(i) Mesh topology

(ii) Tree topology

(iii) Ring topology

(d)Briefly explain three (3) benefits of using Local Area Networks In any government institution in Tanzania.

SECTION C (30 Marks)

Answer ONLY TWO (2) Questions from this section

9. Why schools should include the use of Information and Communication Technology in teaching and learning process? Explain by giving five (5) reasons.

10. Explain five (5) devices that are used to protect a computer and other electrical equipment from the effects of power fluctuation.

11. Explain five (5) aids that can be used in electronic presentation.

THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION & LOCAL GOVERNMENT

KILIMANJARO FORM FOUR MOCK EXAMINATION

036/1 INFORMATION AND COMPUTER STUDIES 1

TIME 3 HOURS MAY 2023

INSTUCTIONS:

1. This paper consists of section A, B and C with a total of Eleven (11) Questions
2. Answer all questions in Section A, B and two (2) Questions from section C
3. Your work should be clearly Shown
4. Write your Examination Number on every page
5. Mobile Phone are Not allowed in the examination room

SECTION A

1. For each of the following items (i) – (x) choose the most correct answer among the alternatives provided and write its letter beside the item number in the booklet provided.

(i) As far as database is connected, the field which prevents a user from making double entries in the database table is;

1. Query
2. Foreign key
3. Security key
4. Primary key
5. Validation rule

(ii) A medium of communication that transfer signals along a cable using light is known as

1. Twisted pair cable
2. Coaxial cable
3. Ethernet
4. Unshielded twisted cable
5. Optical fiber cable

(iii)Which of the following is correct according to Microsoft Excel function?

1. = SUM (A1”. A2”. A3”)
2. =SUM(A1,A2,A3)
3. SUM (A1:A3)
4. TOTAL (A1:A3)
5. A1+A2+A3

(iv) Refer to the use of computer to defile records and steal money:

1. Fraud
2. Piracy
3. Hacking
4. Vandalism
5. Cracking

(v) Most of modern computers are installed with the CMOS battery which held date and time among other functions, what are the other details which are held in the CMOS:

1. Operating system
2. Application software
3. Basic Input/ Output system detail
4. Anti- virus
5. Database

(vi) The school administration experience irregular and frequent high -power in their computer laboratory. What advice would you give them so that they protect their computers.

1. To install Voltage regulator
2. To install UPS
3. To install Firewall
4. To install surge protector
5. To have standby fire extinguisher

(vii) ________allows to recognize and add more effects to your digital footage

1. Audio editing software
2. Video editing software
3. Paint program
4. Animation
5. Browser

(viii) Which among the following is NOT an advantage of print media?

1. Are popular among consumers
2. They are mostly trusted and have many readers
3. They are ideal for discussing confidential information
4. They can easily kept for future use
5. They can easily be used to spread awareness of different matter`s and make advertisement.

(ix) The program that allow hardware and software to work together and act as intermediary the user and the computer hardware is known as:

1. Application software
2. Generic software
3. Operating system
4. System software
5. Utility Software

(x) The area in the CPU that holds the frequently accessed data and instructions

1. Random access memory
2. Cache memory
3. Read only memory
4. Compact disk
5. Memory Card

2. Match the item in LIST A with the correct item in LIST B as used in networking and communication by writing the letter of the most correct answer beside the item number in your booklet(s)

SECTION B (54 MARKS)

3. (a) Multimedia had begun a very long time ago. It is considered to combine texts, images, audio , video and audio visual graphics.

i) Give any four multimedia devices used now days ii) Briefly explain two areas where multimedia is useful iii) With examples Briefly describe interactive content

(b) Electronic learning is now days adapted in many institutions, give two positive aspects of it.

4. Carefully read the database table below and answer the questions that follows:

(a) What is the table name?

(b) How many records are there in the database (c) How many fields are in the database table.

(d) What kind of Data type is used in salary field ?

(e) Suggest the field that should be assigned the primary key and why?

(f) Write the criteria to be used in the sector filed to query employees who have no sector

(g) Write the criteria to query and insert a new filed of VAT , having calculated 18% of salary of each employee.

5. Mr Nguvu has recently bought a person computer but he is not familiar with some application software. As a knowledgeable computer user help with to;

i)Highlight four features which distinguish Desktop publishers software from word processing software

ii)Describe four tools of the tools of the toolbox used to design and manipulate publication.

iii) Describe Why word processor is more preferred than Manual type writer?

6. a) Mr kalmakenge is the customer of Mini commercial bank (RCM).The bank issues plastic cards and unique personal identification number (PIN) to customers so that they can get access to their accounts through a special machine called ATM

i) What do you understand by the term ATM? ii) Why do you think ATM is so important?

iii) Describe the main purpose of customers having a PIN

b) Write the output/display from html code below

<html>

<head>

<title> html code </title>

</head>

<body>

<table border="1">

<tr>

<td>

<form action="send" >

<H3 ALIGN="CENTER">KILIMANJARO REGIONAL COMMISSIONER'S OFFICE</H3>

<H4 ALIGN="CENTER">MOCK EXAMINATIONS FOR FORM IV</H4>

Choose the subject you like from the following list:<BR//>

<input type="radio" name="ICS" checked >ICS <BR/>

<input type="radio" name="KISW" >KISWAHILI <BR/>

<input type="submit" value="SEND" >

</form>

</td>

</tr>

</table>

</body>

</html>

7. a) Mr. Kishikwambi asked his students to propose the devices they could purchase that can be useful in establishment of computer network in the school. As a computer student , what are the five basic devices that you will tell Mr. Kishikwambi ? Let him know about their functions also.

b) A certain company would like to establish a network in their office. As expert explain to the manager with the aid of diagram two topologies that they can use.

8. a) computer hardware are categorized based on their operations, namely input, processing and output. Describe them briefly giving one example each.

b) Computers can be classified in different ways, but just give your classification based on the types of signals they use, and give some explanation.

SECTION C (30 MARKS)

Answer two (2) questions from this section

9. As a form four student taking ICS, you have visited the academic office and after observing the way they are keeping students file by using paper files, write your proposal to convince the school administration to shift from paper files to Electronic database. (4 points)

10. ICT facilitates communications from one place to another, where by it has increased the transfer speed and reduce the distance where the information or data is sent although there are some barriers of communication. Explain with example four (4) barriers of communication as far as ICT is concerned.

11. In the world today, education is growing so fast, internet has served a great services in E-learning, from your knowledge about internet and networking, explain with examples four (4) merits of E-learning.

THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

 ZONAL FORM FOUR MOCK EXAMINATIONS 

(NJOMBE, MBEYA, SONGWE, RUKWA AND KATAVI REGIONS)

36/01 INFORMATION & COMPUTER STUDIES 1

TIME 3:00 HOURS YEAR: 2023

INSTRUCTIONS

1. This paper consists of section A, B and C with a total of eleven (11) questions.
2. Answer all questions in sections A and B and only TWO (2) questions from section C
3. Section A carries sixteen (16) marks, section B fifty-four (54) marks, and section C carries thirty (30) marks.
4. Cellular phones are not allowed in the examination room
5. Write your Examination number on every page of your answer booklet(s)

SECTION A: (16 Marks)

Answer all questions in this section.

1. For each of the following items (i) - (x), choose the correct answer from the given alternatives and write the item in the answer booklet provided.

i. The origination of the message or information to be disseminated is called;_____

1. Medium 
2. Source 
3. Feedback 
4. Receiver E
5. Channel [      ] 

ii. Cells A4, A7, C4, C5 and C7 contain values 5, 10, 8, 2 and 4 respectively. In cell D8 a formula

= C5 * (A4 + A7) – (C4 / C7) is entered what will be the result displayed?______

1. 18 
2. 14 
3. 12 
4. 16 
5. 28  [      ] 

iii. The best application program used to collect related file is known as __________

1. Access 
2. Dogslide 
3. Spreadsheet 
4. Adobe maker 
5. Power ISO [      ] 

iv. Publishing a webpage means__________________

1. To transfer data from flash disk to a computer 
2. To transfer web pages to web server
3. To transfer power from system unit to monitor
4. To transfer data from computer to internet explorer
5. Transfer data to the desktop. [      ] 

v.  the name of this cell will be; __________

1. Empty cell 
2. A1 
3. 1A 
4. A 
5. Active cell  [      ] 

vi. Your ICS teacher bought a new computer which was installed with windows 7 only. What other type of programs teachers my required to perform specific tasks like presentation, word processing and games?_______________

1. Utility software 
2. Operating system 
3. Free software 
4. Application software
5. System software [ ]

viii. Headmistress enters data on html software, but when she run it, the table row fails to display on website, which code is necessary to be applied?__________________

1. </tb> <tb> 
2. <tr> </a> 
3. <tr> </tb> 
4. <tr> </tr> 
5. <tb> </tb>   [      ] 

ix. ________________________ is a name used to identify a computer in a network

1. MAC address 
2. IP address 
3. NIC 
4. Protocol 
5. URL  [      ]  

x. A collection of related web pages that you can access electronically is called?___

1. Internet 
2. Internet explorer 
3. Websites 
4. Electronic web page
5. Google Chrome  [      ] 

x. Assume you are using MS word, which windows feature will show you the name of the document and program.:___________________

1. Menu bar 
2. Title bar 
3. Ribbon 
4. Tool bar 
5. Status  [      ] 

2. March the following computer hardware in a LIST A with their corresponding use in LIST B by writing the correct letter of the correct option beside the item number in your answer booklet. (6 marks)

SECTION B: (54 marks)

Answer all questions in this section

3. (a). You are provided with five statements about printing handout from the saved presentation document on your computer. Rearrange the statements from the first to the last by writing i ts letter.

A. Type the number of copies and click print button. B. Choose print and select the printer.

C. Open the document. D. On print setting, choose handout of six.

E. Click file tab/office button from the menu bar(5 marks)

(b). Presentation is said to both an art and science. As a science there are principles that you need to observe to deliver a good presentation. And as an art there are principles you need to follow as part of presentation. Describe four steps of preparing a presentation. (4 marks)

4. (a). Computers are electronic devices used to process data and give out information according to the list of instructions. Explain five characteristics of computer which makes it differ from other electronic devices.(5 marks)

(b). VUMA club wish to prepare their materials in modern ways, as ICS student explain to them any four multimedia devices that they can used to prepare those materials. (4 marks)

5. Study carefully Figure below and then answer the questions that follows:

a. What topic has presented on figure above? (1 marks)

b. List one function for each following devices as they used on figure above:

i. Server ii. Firewall iii. Switch (3 marks)

c. Explain five advantages of using internet (5 marks)

6. (a). a) write html codes used to display the output below. (5 marks)

(b). Write the extensions of the following file as used in computer to identify the file types (4 marks)

i. A plain text ii. Data file created in MS Word

iii. Data file created in MS Excel iv. Data file created in MS PowerPoint

7. A company stores a stock list of spinets in a computer file. Several records are shown in the diagram

1. Write down data type for LOCATION CODE field and SELL field. (1Mark) 
2. Which field would be used as a key field?(1Mark) 
3. Differentiate between Select query and Action query.(2Marks) 
4. Draw a dynaset which will be displayed if the following search condition is entered when creating a query. (SELL ($) >300) and (colour = “B”) (2Marks)
5. List any three advantages of database management system (3 marks)

8. (a). A computer malware is a malicious program written by people aiming to conduct unwanted operations such as damaging disks and deleting data. Mention four malware preventive measures (4 marks)

(b). Study the figure below carefully so as to answer the question that follows (i-v);

1. Provide a name for an active cell (1 marks) 
2. Write the function used in column G (1 marks) 
3. Write the function used to get values in column H (1 marks) 
4. How many rows do we have in a figure? (1 marks)
5. What will happen in Column H if ICS values are changed? (1 marks)

SECTION C: 30 MARKS

Answer only two questions from this section.

9. Kazikazi attend one of computer course (desktop publisher), on the end of course the teacher asked him to explain the advantages and disadvantages of desktop publishing in school context. As ICS students, give three advantages and three disadvantages of desktop publishing? (15 marks)

10. Mr. Martin is normally using computer for many hours every day when he is at his office. What five health problems he will face(15 marks)

11. ICT plays great role in combating corruption. Explain six (6) contributions of ICT in eradicating corruption in Tanzania (15 marks)

THE UNITED REPUBLIC OF TANZANIA NATIONAL EXAMINATION COUNCIL OF TANZANIA

FORM IV MOCK EXAMINATION 2020 

DODOMA REGION

036/1 INFORMATION AND COMPUTER STUDIES 1

Time: 3HRS Wednesday, 12 August 2020 p.m.

Instructions

1. This paper consists of sections A, B and C with a total of twelve (12) questions.
2. Answer all Questions in sections A, B and one question in section C.
3. Calculators, cellular phones and any unauthorized materials are not allowed in the examination room
4. Write your Examination Number on every page of your answer booklet(s).

SECTION A (15 Marks)

Answer all question in this section

1. For each of the items (i)-(x) choose the correct answer from among the given alternatives and write its letter beside the item number in the space provided.

i. How can you classify the lap top and desktop computer?

1. portable computers 
2. supercomputer 
3. microcomputer
4. minicomputer

ii. The database object that enables you to view and print data from a database table in a chosen appearance is called

1. a form 
2. a query 
3. a table 
4. a report

iii. The problem of eye strain which is caused by spending a lot of time on using computers can be minimized by

1. taking regular break and using antiglare screen
2. using adjustable monitor stands and keyboards
3. adopting a healthy sitting style
4. using adjustable chairs and footrests

iv. Which program would you use in preparing application letter

1. Microsoft excel 
2. Microsoft word
3. Microsoft power point 
4. Microsoft access

v. Which keyboard keys are referred to as special purpose keys in a personal computer?

1. F1, F2, F3 up to F12 
2. A to Z, Tabs, Caps lock and 0-9
3. Arrow keys, Tab and Home key 
4. SHIFT, Ctrl, Alt and ESC

vi. Which printer would you suggest for printing school examination?

1. Photo printers 
2. Plotter printers
3. Laser printers 
4. Dot matrix printer

vii. Word processor supports enhancement of the documents appearance to make font type and font style more appealing. What action classifies this feature of a word processor?

1. creating documents 
2. editing documents
3. formatting documents 
4. decorating documents

viii. Which tag would you use to emphasize the heading of the article in the webpage?

1. <head> </head> 
2. <title> </title>
3. <hr> </hr> 
4. <th></th>

ix. What is alternative name of utility program?

1. Operating program 
2. Application program
3. Software program 
4. Interface program

x. Which device would you use to connect seven computers so that they can share the same bandwidth?

1. Switch 
2. Router 
3. Hub 
4. Modem

2. Match the following descriptions of text alignment used in Microsoft word in List A to their corresponding types of alignments in List B

SECTION B, (75 Marks)

Answer all question in this section

3 Arrange the following in terms of Computer generation (10marks)

i. The computer used Transistors replaced

ii. Used in intelligent robot

iii. The computer used vacuum tubes for circuitry and magnetic drums for memory

iv. Integrated circuit

v. Used in virtual reality a multimedia stimulator

4 a) Explain how to search for information on the web using a search engine (2.5 marks)

b). differentiate between the following terms (4.5 marks)

i. hackers and crackers

ii. security and privacy

iii. internet and intranet

c). Outline types of malicious software that can negatively affect a computer system (3mark)

5 a). Computer users complained for the frequently headaches and fatigue after using the computers in the computer room. State three reasons that could cause these conditions. (3marks)

b). Explain why modern computers are referred to as electronic devices (3marks)

6 (i) What is database management system (DBMS) (2 marks)

(ii) Differentiate between Query and form as used in database (2 marks)

(iii) An electronic database depends on database management system. Why do you think database management system (DBMS) is important software in developing electronic database? (3 points) (6 marks)

7 a) Describe three parts of E-mail (3 marks)

b). Explain how you would send an e-mail that include photos of your birthday to the three friends, one Ludewa and the other in Nairobi and Kigali (4 marks)

c). Explain how you can use instant messenger to chat with colleagues located anywhere in the world (3 marks)

9 a).Mr. Mtweve works up one day only to find his computer dead. Suggest three causes of failure and how to avoid the problem in future (6 marks)

b). Some devices have a combination of input and output functionality. State four such devices (2marks)

c). Explain four data types in worksheet (2 marks)

10 a) What do you understand by the term desktop publisher? (2 marks)

b) Give four examples of desktop publishing software available in the market today (4 marks)

c) Explain four reasons why desktop publishing is more preferred than a word processor? (4marks

SECTION C, (10 Marks)

Answer one (1) Question from this section

11. The ICS teacher wanted to connect his computer to the network for ease downloading teaching and learning materials. Explain four (4) factors that affect network connection.

12. The introduction of computers to the society reveals many benefits. Explain four advantages acquired by developing countries such as Tanzania. (10marks)